Computer Science Lesson Plan
Class: 5 - Lesson: 6.1 Spreadsheet (Basic Operations)

Purpose: To learn basic operations such as addition, subtraction, multiplication and division in a spreadsheet.

No. of Classes

One class (teacher's decision).

Material Required

OpenOffice (Spreadsheet).

Curriculum Content
  • 7) Open office - Spread sheet
  • 7.2) Cell properties
  • 7.2.16) Simple formulae usage
    •

    Prior Knowledge

    Students should know:

  • The editing operations of cells.
  • The properties of cells.

    • Exercise

    Exercise 1


    1. Add, subtract, multiply and divide using spreadsheet operators.

    Solutions


  • Link to view the solution video for Exercise 1.

    • Teacher Instructions
    1. Teachers should explain the importance of formulae in spreadsheets.
    2. Teachers should also explain the autofill feature (drag the autofill handle at the bottom right of a cell) and how this is useful in filling dates, days or serial numbers.
    3. Teachers should explain that the numbers in the leftmost column indicate row numbers, and the letters in the topmost row indicate columns in a spreadsheet.
    4. Teachers should ensure that students practise all these features.